Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# DBA_SQLTUNE_RATIONALE_PLAN

`DBA_SQLTUNE_RATIONALE_PLAN` displays the association between rationales and operations in the execution plan of all SQL statements in the database.

Related View

`USER_SQLTUNE_RATIONALE_PLAN` displays the association between rationales and operations in the execution plan of the SQL statements owned by the current user.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`TASK_ID` | `NUMBER(38)` | `NOT NULL` | Tuning task identifier
`RATIONALE_ID` | `NUMBER(38)` | `NOT NULL` | Rationale identifier
`OBJECT_ID` | `NUMBER(38)` | `NOT NULL` | Advisor framework object identifier
`OPERATION_ID` | `NUMBER(38)` | `NOT NULL` | Operation identifier
`PLAN_ATTRIBUTE` | `VARCHAR2(27)` |  | Type of the execution plan: `Original` - Original plan of the query `Original with adjusted cost` - Same as `Original` but with adjusted cost `Using SQL profile` - Plan with sql profile applied `Using new indices` - Plan with indexes applied

See Also: "USER_SQLTUNE_RATIONALE_PLAN"